package com.loveyukari.dao;

import java.util.Date;
import java.util.List;

import com.loveyukari.model.Music;
import com.loveyukari.model.SongSheet;

import net.sf.json.JSONObject;

/**
*
*yangshaohua
*2017年3月3日下午3:19:56
**/
public interface YukariMusciDao {
	
	void updateMusic(Music music);
	
	void insertMusic(Music music);
	
	List<Music> selectListByType(String type);
	
	List<Music> selectListByAll();
	
	List<Music> selectListBySearch(String type, String query, String order);
	
	List<Music> selectListBySize(String query, int size);
	
	Music select(int id);
	
	
	List<JSONObject> selectSongSheetGroupDate();
	
	List<Integer> selectMusicIdbySheet(Date date);
	
	void insertSongSheet(SongSheet songSheet);
	
	
	
}
